1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Data.SqlClient;
6 using System.Drawing;
7 using System.Linq;
8 using System.Text;
9 using System.Threading.Tasks;
10 using System.Windows.Forms;
11 //using System.Xml;
12
13 /**
14 * --https://stackoverflow.com/questions/38401803/c-sharp-winforms-form-show-cmd
15 * /
16 *
17 /*
18 * Định nghĩa các giá trị trạng thái
19 * TrangThai = 0; không hiển thị
20 * = 1; Hiển thị
21 * tbl_BanHang TrangThai = 2 (Hiển thị; Nhưng bản ghi vừa thêm không có trong bảng tbl_NhapKho)
22 *
23 *
24 */
25
26 /*
27 *
28 * UPDATE
29 Table_A
30 SET
31 Table_A.DonViTinhId = Table_B.IdDonViTinh,
32 Table_A.TenDonViTinh = Table_B.TenDonViTinh
33 FROM
34 tbl_ThongTinSanPham AS Table_A
35 INNER JOIN tbl_DonViTinh AS Table_B
36 ON Table_A.TenDonViTinh = Table_B.TenDonViTinh
37 and Table_A.GhiChu like '%xxxxxxxxx.vn%';
38 *
39 * UPDATE
40 Table_A
41 SET
42 Table_A.DonViTinhId = Table_B.IdDonViTinh
43 FROM
44 tbl_ThongTinSanPham AS Table_A
45 INNER JOIN tbl_DonViTinh AS Table_B
46 ON Table_A.TenDonViTinh = Table_B.TenDonViTinh;
47 */
48
49 /*
50 * Ghi chú
51 * Khai báo biến là rỗng : string strX = string.Empty
52 * Kiểm tra là rỗng:
53 * if(!string.IsNullOrEmpty(strX))
54 * {
55 *
56 * }
57 *
58 *
59 * string formatTuNgay = "dd/MM/yyyy";
60 DateTime dateTimeTuNgay;
61 *if (DateTime.TryParseExact(maskedTextBox_TuNgay.Text, formatTuNgay, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTimeTuNgay))
62 {
63 _tuNgay = DateTime.ParseExact(maskedTextBox_TuNgay.Text, "dd/MM/yyyy", null);
64 }
65 else
66 {
67 _tuNgay = DateTime.Parse("2000-01-01");
68 }
69 *
70 */
71
72 /*
73 * Bảng tbl_BanHang
74 * TrangThai = 2 là hàng khuyễn mãi
75 * TrangThai = 0 bán hàng không thanh toán
76 * TrangThai = 1 bán hàng có thanh toán
77 *
78 */
79
80 //hien thị lable text ra giữa
81 //-https://stackoverflow.com/questions/21218729/how-do-i-align-my-text-in-a-label-to-the-right-side
82
83 /*
84 * Hiển thị - [] X bên phải form
85 * ControlBox = true Hoặc ControlBox = false
86 * MinimizeBox = false; ẩn dấu trừ
87 */
88
89 /*
90 * ComboBox khong cho edit
91 * DropDownStyle = DropDownList
92 */
93
94 /*
95 * Lua active chuot
96 * this.ActiveControl = txtMaSanPham;
97 */
98
99
100 /*
101 * Hien thi xuong dong row datagridview
102 * AutoSizeRowMode = displaycell
103 */
104
105 /*
106 *
107 * SQL get Ngay/Thang/Nam
108 * CONVERT(VARCHAR(26), @NgayBanHang, 23) //yyyy-MM-dd sql 2008
109 * CONVERT(VARCHAR(7), b.NgayBatDau, 120) //yyyy-MM
110 *
111 * FORMAT(@NgayBanHang,'yyyy-MM-dd') >= FORMAT(b.NgayBatDau,'yyyy-MM-dd')
112 *
113 * ngày mặc định search
114 * @NgayMuaHang = '2000-01-01'
115 *
116 */
117
118 /*
119 * TongDonHang nhap hang
120 * ,(Select ISNULL(SUM(k.GiaNhap * k.SoLuong - ((CASE WHEN k.ChietKhauTheo = 'PhanTram' THEN k.GiaNhap * k.SoLuong * k.ChietKhauPhanTram / 100 ELSE k.TienChietKhau END)) + (k.SoLuong * k.GiaNhap * k.Thue / 100)), 0)) as TongDonNhapHang
121 */
122
123 /*
124 * Tự động ẩn thông báo lblThongBao
125 * -https://stackoverflow.com/questions/15951689/show-label-text-as-warning-message-and-hide-it-after-a-few-seconds
126 *
127 * var t = new System.Windows.Forms.Timer();
128 t.Interval = 3000; // it will Tick in 3 seconds
129 t.Tick += (s, ex) =>
130 {
131 lblThongBao.Visible = false;
132 t.Stop();
133 };
134 t.Start();
135 *
136 *
137 */
138
139 /*
140 * b2.IdBom IN (SELECT * FROM fnSplit(@IdBomStr,';'))
141 */
142
143 /*
144 *
145
146 declare @tblTtSp table(
147 msp nvarchar(100),
148 col int
149 );
150
151 insert into @tblTtSp(msp, col) SELECT MaSanPham, COUNT(1) FROM tbl_ThongTinSanPham
152 GROUP BY MaSanPham
153 HAVING COUNT(1) > 1
154
155 select tt.IdThongTinSanPham, tt.MaSanPham, tt.TenSanPham, tt.TenNhaCungCap, tt.DonViTinhId from tbl_ThongTinSanPham tt where tt.MaSanPham IN (Select msp from @tblTtSp)
156 order by tt.MaSanPham asc
157 *
158 */
159
160 /*
161 *
162 *
163 -- 28010 --
164 -- 89346 --
165 UPDATE tbl_ThongTinSanPham
166 SET MaSanPham = REPLACE(MaSanPham, ' ', '')
167 where CONVERT(VARCHAR(26), NgayTao, 23) = '2017-12-24'
168 * */
169
170 namespace SoftQuanLyNhaHang.Views
171 {
172
173 public delegate void PassData_CallTo(string textBoxData); //note where this is placed. After namespace, but before any class
174
175 public partial class frmMain : Form
176 {
177 //uctQuanLyHoaDon _myUserControl = new uctQuanLyHoaDon();
178
179 public frmMain()
180 {
181 InitializeComponent();
182
183 //Chay file cau hinh he thong dau tien
184 this.CauHinh_HeThong();
185
186 //-https://stackoverflow.com/questions/21061160/how-to-click-a-button-on-form-load-using-c-sharp
187 //Hiển thị dashboard khi load lần đầu tiên
188 //this.Load += dashboardToolStripMenuItem_Click;
189 this.Load += banHangToolStripMenuItem_Click;
190
191 //click tu trang thai quan ly don hang
192 uctQuanLyHoaDon.uctQLHD.Link_TrangThai_Get_NhapHang_ChiTiet += new Dgv_TrangThai_ByNhapHang_EventHandler(DgvCell_Click_TrangThai);
193
194 //click tu nhap hang --> chi tiet
195
196 //uctNhapHang_ChiTiet.uctNh_Ct.btn
197 uctNhapHang.uctNH.btnClickSendLink_NhapHang_ChiTiet += new BtnClick_NhapHang_ChiTiet_EventHandler(ChiTietNhapHang_ClickShow);
198
199 //Sửa đơn hàng
200 uctNhapHang_ChiTiet.uctNh_Ct.Link_SuaDonHang_Get_UctNhapHang += new LinkSuaDonHang_EventHandler(SuaDonHangClick);
201
202 //Thêm mới Bom
203 uctBom_GoiSanPham.uctBomGsp.Link_ThemMoiBom += new LinkThemMoiBom_EventHandler(ThemMoiBom_GoiSanPham);
204
205 //xem chi tiết bom
206 uctBom_GoiSanPham.uctBomGsp.Link_XemChiTiet_Bom += new LinkXemChiTiet_Bom_EventHandler(XemChiTiet_Bom_GoiSanPham);
207
208 //Sửa bom
209 uctBom_ChiTiet.uctBomCt.Link_SuaBom += new LinkSuaBom_EventHandler(SuaBom);
210
211 //Kho click menu form gọi đến kiểm tra kho
212 uctKho.uctK.Link_DanhSach_KiemKho += new LinkDanhSach_KiemKho_EventHandler(DanhSachKiemKhoClick);
213
214 //danh sach ton kho
215 uctKho.uctK.Link_DsachTonKho += new Link_DsachTonKho_EventHandler(DanhSachTonKho);
216
217 //show form kiểm kho
218 uctKho_KiemTraKho_List.uctK_ktk_List.Link_KiemTraKho_ShowForm += new LinkKiemTraKho_ShowForm_EventHandler(FormKiemKhoClick);
219
220 //kiểm kho xem chi tiết
221 uctKho_KiemTraKho_List.uctK_ktk_List.Link_KiemKho_ChiTiet += new LinkKiemTraKho_ChiTiet_EventHandler(KiemKhoChiTiet);
222
223 //kiểm kho xem chi tiết click thay đổi
224 uctKho_KiemTraKho_ChiTiet.uctKtk_Ct.Link_KiemKho_ThayDoi_Click += new LinkKiemKho_ThayDoi_GetForm_EventHandler(KiemKhoChiTietThayDoi);
225
226 //bao cao ket thuc ngay lam viec
227 uctBaoCao.uctBC.btnKetThucNgayLamViec += new btnKetThucNgayLamViec_EventHandler(BC_KetThucNgayLamViec);
228
229
230 //chi tiết sản phẩm
231 uctKho.uctK.Link_ChiTietSanPham += new LinkChiTietSanPham_EventHandler(ChiTietSanPhamClick);
232
233 //ban hàng
234 uctDashboard.uctDB.Link_BatDau_BanHang += new LinkBatDau_BanHang_EventHandler(ClickBatDau_BanHang);
235 //nhập hàng
236 uctDashboard.uctDB.Link_BatDau_NhapHang += new LinkBatDau_NhapHang_EventHandler(ClickBatDau_NhapHang);
237
238 //khoa so ngay hom nay
239 uctDashboard.uctDB.Link_BC_KhoaSoNgayHomNay += new LinkBC_KhoaSoNgayHomNay_EventHandler(BC_KhoaSoNgayHomNay);
240
241 //chi tiet tong don hang
242 uctDashboard.uctDB.Link_BC_Tong_DonHang += new LinkBC_Tong_DonHangTrongNgay_EventHandler(DB_TongDonHang);
243
244 //quan ly thu chi
245 uctCongNo_Ncc_Kh.uctCn_Ncc_Kh.Link_ThuChi += new Link_ThuChi_EventHandler(DanhSach_ThuChi);
246
247 //quan ly ncc
248 uctCongNo_Ncc_Kh.uctCn_Ncc_Kh.Link_QuanLyNhaCungCap += new Link_QuanLyNhaCungCap_EventHandler(QuanLy_NhaCungCap);
249
250 //quan ly kho
251 uctQuanLyHoaDon.uctQLHD.Link_QuanLyKho += new Link_QuanLyKho_EventHandler(QuanLy_Kho);
252
253 //them moi don hang
254 uctQuanLyHoaDon.uctQLHD.Link_ThemMoiDonHang += new Link_ThemMoiDonHang_EventHandler(ThemMoiDonHang_NhapHang);
255
256 //Cau hinh
257 uctDashboard.uctDB.Link_CauHinh += new Link_CauHinh_EventHandler(CauHinhHt);
258
259 //ds ban hang
260 uctBaoCao.uctBC.Link_DsSanPhamDaBan += new Link_DsSanPhamDaBan_EventHandler(DsSanPhamDaBan);
261
262 //bom va goi san pham
263 uctQuanLyMuaHang.uctQLMh.Link_BOMGoiSanPham += new Link_BOMGoiSanPham_EventHandler(BomVaGoiSanPham);
264
265 //quay lai bom
266 uctBom_Form.uctBomF.Link_QuayLai += new Link_QuayLai_EventHandler(BomQuayLai);
267 uctBom_ChiTiet.uctBomCt.Link_QuayLai_BomCt += new Link_QuayLai_BomChiTiet_EventHandler(BomChiTietQuayLai);
268
269 //hien thi danh sach don hang
270 uctCongNo_Ncc_Kh.uctCn_Ncc_Kh.Link_DanhSDonNhapHang_ByIdNcc += new Link_DanhSDonNhapHang_ByIdNcc_EventHandler(HienThiDsNcc);
271
272 //chi tiet nhap hang
273 uctNhapHang_ChiTiet.uctNh_Ct.Link_ChiTietDonHang_Dong_UctNhapHang += new Link_ChiTietDonHang_Dong_UctNhapHang_EventHandler(DongNhapHangChiTiet);
274
275 //chi phi
276 uctBaoCao.uctBC.Link_ChiPhi_DsCp += new Link_ChiPhi_DsCp_EventHandler(BC_ThemGet_Uct_BaoCao_HienTHi);
277
278 //ton kho
279 uctBaoCao.uctBC.Link_BaoCTonKho += new Link_BaoCTonKho_EventHandler(BC_HangTonKho);
280
281 //cong no ncc
282 uctBaoCao.uctBC.Link_CongNoNcc_InBC += new Link_CongNoNcc_InBC_EventHandler(congNoBaoCaoToolStripMenuItem_Click);
283
284 //dashboard
285 uctDashboard.uctDB.Link_BOM_VaGoiSanPham += new Link_BOM_VaGoiSanPham_EventHandler(bomGoiSanPhamToolStripMenuItem_Click);
286
287 uctDashboard.uctDB.Link_NhaCc_Dashboard += new Link_NhaCc_Dashboard_EventHandler(nhaCungCapToolStripMenuItem_Click);
288
289 uctDashboard.uctDB.Link_ThuChi_Dashboard += new Link_ThuChi_Dashboard_EventHandler(congNoToolStripMenuItem_Click);
290
291 uctDashboard.uctDB.Link_QuanLyKho_Dashboard += new Link_QuanLyKho_Dashboard_EventHandler(khoToolStripMenuItem_Click);
292
293 uctKho_ChiTietSanPham.uctKho_CtSp.Link_HtDsKho_ChiTietSp +=new Link_HtDsKho_ChiTietSp_EventHandler(HienThiThongTinSpKhoKhiUpdate);
294
295 //bao cao
296 uctDashboard.uctDB.Link_LapBaoCao_Dashboard += new Link_LapBaoCao_Dashboard_EventHandler(baoCaoToolStripMenuItem_Click);
297
298 //cong no
299 uctDashboard.uctDB.Link_CNo_Dashboard += new Link_CNo_Dashboard_EventHandler(congNoBaoCaoToolStripMenuItem_Click);
300
301 //hien thi scanner
302 uctCauHinhHeThong.uctCHHT.Link_Scanner_CheckSp += new Link_Scanner_CheckSp_EventHandler(scannerToolStripMenuItem_Click);
303 }
304
305
306
307 //void MainWindow_myevent(object sender, EventArgs e)
308 //{
309 //uctDashboard db = new uctDashboard();
310 //db.MyText = _myUserControl.MyText;// _.MyText;
311 //}
312
313 protected void DgvCell_Click_TrangThai(object sender, EventArgs e, int IdNhapHang, int nhaCungCapId, string trangThaiNhapHang)
314 {
315 //hanh dong sau click
316 //ThemTabPages(Views.uctNhapHang.uctNH, 5, "Nhập hàng");
317
318 //uctNhapHang.uctNH.HienThiDanhSachSanPham_Kho_ByIdNhapHang(IdNhapHang, nhaCungCapId, trangThaiNhapHang);
319
320 //Hiển thị chi tiết nhập hàng
321 ThemTabPages(Views.uctNhapHang_ChiTiet.uctNh_Ct, 6, "Chi tiết đơn hàng");
322
323 //hien thi thong tin trong don hang
324 uctNhapHang_ChiTiet.uctNh_Ct.HienThiChiTietDonHang(IdNhapHang, nhaCungCapId, trangThaiNhapHang);
325
326 }
327
328 //click sửa đơn hàng
329 protected void SuaDonHangClick(object sender, EventArgs e, int IdNhapHang, int nhaCungCapId, string trangThaiNhapHang)
330 {
331 DongTabHienTai();
332 //hanh dong sau click
333 ThemTabPages(Views.uctNhapHang.uctNH, 5, "Sửa đơn hàng");
334
335 uctNhapHang.uctNH.HienThiDanhSachSanPham_Kho_ByIdNhapHang(IdNhapHang, nhaCungCapId, trangThaiNhapHang);
336
337 }
338
339
340
341
342
343
344
345 //DataTable dtCauHinh = new DataTable();
346
347 internal static List<byte> typePages = new List<byte>();
348
349 //public TabPage tb;
350
351 public void ThemTabPages(UserControl uct, byte typeControl, string tenTab)
352 {
353 try
354 {
355 // Kiểm tra tồn tại trang này chưa
356 for (int i = 0; i < tabControl_TabHienThi.TabPages.Count; i++)
357 {
358 if (tabControl_TabHienThi.TabPages[i].Contains(uct) == true)
359 {
360 tabControl_TabHienThi.SelectedTab = tabControl_TabHienThi.TabPages[i];
361 return;
362 }
363 }
364 TabPage tab = new TabPage();
365 typePages.Add(typeControl);
366 tab.Name = uct.Name;
367 tab.Size = tabControl_TabHienThi.Size;
368 tab.Text = tenTab;
369 tabControl_TabHienThi.TabPages.Add(tab);
370 tabControl_TabHienThi.SelectedTab = tab;
371 uct.Dock = DockStyle.Fill;
372 tab.Controls.Add(uct);
373
374 uct.Focus();
375 }
376 catch { }
377
378
379 }
380 public void DongTabHienTai()
381 {
382 tabControl_TabHienThi.TabPages.Remove(tabControl_TabHienThi.SelectedTab);
383 }
384 public void DongAllTab()
385 {
386 while (tabControl_TabHienThi.TabPages.Count > 0)
387 {
388 DongTabHienTai();
389 }
390 }
391
392 DataTable dtCauHinh = new DataTable();
393
394 private void CauHinh_HeThong()
395 {
396
397 //khong ket noi dc csdl thi hien form ket noi len
398 if (CauHinhHeThong.KET_NOI_CSDL == true)
399 {
400 //da ket noi dc csdl
401 dtCauHinh = Controllers.CauHinhHeThongCtrl.FillDataSet_getAllCauHinhHeThong().Tables[0];
402 if (dtCauHinh.Rows.Count > 0)
403 {
404 foreach (DataRow dtRow in dtCauHinh.Rows)
405 {
406 try
407 {
408 string KhoaChinh = dtRow["KhoaChinh"].ToString();
409 switch (KhoaChinh)
410 {
411 case "DAU_PHAY":
412 {
413 CauHinhHeThong.DAU_PHAY = dtRow["GiaTri"].ToString();
414 break;
415 }
416 case "PHAN_CACH_HANG_NGHIN":
417 {
418 CauHinhHeThong.PHAN_CACH_HANG_NGHIN = dtRow["GiaTri"].ToString();
419 break;
420 }
421 case "TIEU_DE_NGU_HOA_DON_BAN_HANG":
422 {
423 CauHinhHeThong.TIEU_DE_NGU_HOA_DON_BAN_HANG = dtRow["GiaTri"].ToString();
424 break;
425 }
426 case "TIEU_DE_NGU_HOA_DON_NHAP_HANG":
427 {
428 CauHinhHeThong.TIEU_DE_NGU_HOA_DON_NHAP_HANG = dtRow["GiaTri"].ToString();
429 break;
430 }
431 case "TIEU_DE_HOA_DON_BAN_HANG":
432 {
433 CauHinhHeThong.TIEU_DE_HOA_DON_BAN_HANG = dtRow["GiaTri"].ToString();
434 break;
435 }
436 case "LUU_THONG_TIN_KHACH_MUA_HANG":
437 {
438 CauHinhHeThong.LUU_THONG_TIN_KHACH_MUA_HANG = dtRow["GiaTri"].ToString();
439 break;
440 }
441 case "BINH_ON_GIA_BAN" :
442 {
443 CauHinhHeThong.BINH_ON_GIA_BAN = dtRow["GiaTri"].ToString();
444 break;
445 }
446 case "KI_HIEU_TIEN_TE":
447 {
448 CauHinhHeThong.KI_HIEU_TIEN_TE = dtRow["GiaTri"].ToString();
449 break;
450 }
451 case "TEN_CONG_TY":
452 {
453 CauHinhHeThong.TEN_CONG_TY = dtRow["GiaTri"].ToString();
454 break;
455 }
456 case "DIA_CHI":
457 {
458 CauHinhHeThong.DIA_CHI = dtRow["GiaTri"].ToString();
459 break;
460 }
461 case "WEBSIETE":
462 {
463 CauHinhHeThong.WEBSITE = dtRow["GiaTri"].ToString();
464 break;
465 }
466 case "HOTLINE":
467 {
468 CauHinhHeThong.HOTLINE = dtRow["GiaTri"].ToString();
469 break;
470 }
471 case "PRINT_WIDTH":
472 {
473 CauHinhHeThong.PRINT_WIDTH = 444;
474 break;
475 }
476
477 case "PRINT_HEIGHT":
478 {
479 CauHinhHeThong.PRINT_HEIGHT = 630;
480 break;
481 }
482 case "IN_HOA_DON_SAU_KHI_BAN":
483 {
484 CauHinhHeThong.IN_HOA_DON_SAU_KHI_BAN = dtRow["GiaTri"].ToString();
485 break;
486 }
487 case "BARCODE_THANH_TOAN_BAN_HANG":
488 {
489 CauHinhHeThong.BARCODE_THANH_TOAN_BAN_HANG = dtRow["GiaTri"].ToString();
490 break;
491 }
492 case "BARCODE_THEM_MOI_KHACH_HANG":
493 {
494 CauHinhHeThong.BARCODE_THEM_MOI_KHACH_HANG = dtRow["GiaTri"].ToString();
495 break;
496 }
497 case "BARCODE_DON_HANG_CHUA_THANH_TOAN":
498 {
499 CauHinhHeThong.BARCODE_DON_HANG_CHUA_THANH_TOAN = dtRow["GiaTri"].ToString();
500 break;
501 }
502 default:
503 {
504 //Gia tri mac dinh
505 break;
506 }
507 }
508 }
509 catch
510 {
511 }
512 }
513 }
514 }
515 //
516 }
517
518 private void frmMain_Load(object sender, EventArgs e)
519 {
520
521 }
522
523 private void quảnLýNhânViênToolStripMenuItem1_Click(object sender, EventArgs e)
524 {
525 ThemTabPages(Views.uctNhanVien.uctNV, 4, "Quản lý nhân viên ");
526 }
527
528 private void quảnLýKháchHàngToolStripMenuItem_Click(object sender, EventArgs e)
529 {
530 ThemTabPages(Views.uctKhachHang.uctKH, 4, "Quản lý khách hàng");
531 }
532
533 private void menuItemDongTrang_Click(object sender, EventArgs e)
534 {
535 DongTabHienTai();
536 }
537
538 private void menuItemDongTrangAll_Click(object sender, EventArgs e)
539 {
540 DongAllTab();
541 }
542
543 private void thoátToolStripMenuItem_Click(object sender, EventArgs e)
544 {
545 DialogResult dr = MessageBox.Show("Bạn có muốn thoát ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
546 if (dr == DialogResult.Yes)
547 {
548 this.Close();
549 }
550 else
551 return;
552 }
553
554 private void lựaChọnKhuVựcToolStripMenuItem_Click(object sender, EventArgs e)
555 {
556 ThemTabPages(Views.uctBan.uctban,4,"Quản lý bàn");
557 }
558 private void hệThốngKhuVựcToolStripMenuItem_Click(object sender, EventArgs e)
559 {
560 ThemTabPages(Views.uctKhuVuc.uctKV, 4, "Hệ thống khu vực");
561 }
562
563 private void mónĂnToolStripMenuItem_Click(object sender, EventArgs e)
564 {
565 ThemTabPages(Views.uctLoaiThucDon.uctLTD,4, "Loại thực đơn");
566 }
567
568
569 private void thứcUốngToolStripMenuItem_Click(object sender, EventArgs e)
570 {
571 ThemTabPages(Views.uctThucDon.uctTD, 4, "Danh sách thực đơn");
572 }
573
574 //Nghi
575 private void donViTinhToolStripMenuItem_Click(object sender, EventArgs e)
576 {
577 ThemTabPages(Views.uctDonViTinh.uctDVT, 4, "Đơn vị tính");
578 }
579
580 private void khoToolStripMenuItem_Click(object sender, EventArgs e)
581 {
582 //Gọi đến uct kho
583 ThemTabPages(Views.uctKho.uctK, 4, "Kho");
584 //Gọi đến uct nhập kho
585 //ThemTabPages(Views.uctNhapKho.uctNk, 4, "Nhập kho");
586 }
587
588 private void banHangToolStripMenuItem_Click(object sender, EventArgs e)
589 {
590 //Gọi đến uct nhập kho
591 //ThemTabPages(Views.uctBanHang.uctBH, 4, "Bán hàng");
592
593 if (CauHinhHeThong.KET_NOI_CSDL == false)
594 {
595 frmConnectCSDL frmCsdl = new frmConnectCSDL();
596 frmCsdl.ShowDialog();
597 }
598
599 while (tabControl_TabHienThi.TabPages.Count > 0)
600 {
601 tabControl_TabHienThi.TabPages.Remove(tabControl_TabHienThi.SelectedTab);
602 }
603
604 ThemTabPages(Views.uctBanHang.uctBH, 4, "Bán hàng");
605
606 ctxtmenuTabBan.BackColor = Color.LightGreen;
607
608 uctBanHang.uctBH.HienThiTrangBanHang();
609
610 }
611
612 private void khToolStripMenuItem_Click(object sender, EventArgs e)
613 {
614 ThemTabPages(Views.uctKhachHang.uctKH, 4, "Khách hàng");
615 }
616
617 private void TabHienThi_SelectedIndexChanged(object sender, EventArgs e)
618 {
619
620 }
621
622 private void thietLapSanPhamToolStripMenuItem_Click(object sender, EventArgs e)
623 {
624 //Gọi đến thông tin sản phẩm
625 ThemTabPages(Views.uctThongTinSanPham.uctTTSP, 4, "Thông tin sản phẩm");
626 }
627
628 //private void cauHinhCuaHangToolStripMenuItem_Click(object sender, EventArgs e)
629 //{
630 //ThemTabPages(Views.uctCauHinhHeThong.uctCHCH, 5, "Cấu hình cửa hàng");
631 //}
632
633 private void baoCaoToolStripMenuItem_Click(object sender, EventArgs e)
634 {
635 ThemTabPages(Views.uctBaoCao.uctBC, 4, "Bao cáo");
636 }
637
638 private void dashboardToolStripMenuItem_Click(object sender, EventArgs e)
639 {
640 ThemTabPages(Views.uctDashboard.uctDB, 4, "Dashboard");
641
642 uctDashboard.uctDB.HienThiTrangDashboard();
643 /*
644 if (CauHinhHeThong.KET_NOI_CSDL == false)
645 {
646 frmConnectCSDL frmCsdl = new frmConnectCSDL();
647 frmCsdl.ShowDialog();
648 }
649 */
650
651 }
652
653 private void bomGoiSanPhamToolStripMenuItem_Click(object sender, EventArgs e)
654 {
655 ThemTabPages(Views.uctBom_GoiSanPham.uctBomGsp,4, "BOM & Gói sản phẩm");
656 }
657
658 private void nhaCungCapToolStripMenuItem_Click(object sender, EventArgs e)
659 {
660 ThemTabPages(Views.uctNhaCungCap.uctNCC, 4, "Nhà cung cấp");
661 }
662
663 public void nhapHangToolStripMenuItem_Click(object sender, EventArgs e)
664 {
665 ThemTabPages(Views.uctNhapHang.uctNH, 4, "Nhập hàng");
666 }
667
668 private void congNoToolStripMenuItem_Click(object sender, EventArgs e)
669 {
670 ThemTabPages(Views.uctCongNo.uctCN, 4, "Quản lý thu chi");
671 }
672
673 private void nhanVienToolStripMenuItem_Click(object sender, EventArgs e)
674 {
675
676 }
677
678 private void theQuaTangToolStripMenuItem_Click(object sender, EventArgs e)
679 {
680
681 }
682
683 private void cauHinhToolStripMenuItem_Click(object sender, EventArgs e)
684 {
685 ThemTabPages(Views.uctCauHinhHeThong.uctCHHT, 4, "Cấu hình hệ thống");
686 }
687
688 //uctQuanLyHoaDon.B += new EventHandler(quanLyHoaDonToolStripMenuItem_Click);
689
690
691 public void quanLyHoaDonToolStripMenuItem_Click(object sender, EventArgs e)
692 {
693 while (tabControl_TabHienThi.TabPages.Count > 0)
694 {
695 tabControl_TabHienThi.TabPages.Remove(tabControl_TabHienThi.SelectedTab);
696 }
697
698 ThemTabPages(Views.uctQuanLyHoaDon.uctQLHD, 4, "Quản lý hóa đơn");
699
700 uctQuanLyHoaDon.uctQLHD.HienThiDsNhapH();
701 }
702
703
704
705 protected void UserControl_ButtonClick(object sender, EventArgs e)
706 {
707 //handle the event
708 }
709
710 private void ctxtmenuTabBan_BackColorChanged(object sender, EventArgs e)
711 {
712 ctxtmenuTabBan.BackColor = Color.Red;
713 }
714
715
716 //chi tiet nhap hang
717
718 protected void ChiTietNhapHang_ClickShow(object sender, EventArgs e, int IdNhapHang, int nhaCungCapId, string trangThaiNhapHang)
719 {
720 while (tabControl_TabHienThi.TabPages.Count > 0)
721 {
722 tabControl_TabHienThi.TabPages.Remove(tabControl_TabHienThi.SelectedTab);
723 }
724
725 //click nhap hang chi tiet
726 ThemTabPages(Views.uctNhapHang_ChiTiet.uctNh_Ct, 4, "Chi tiết nhập hàng");
727
728 //hien thi thong tin trong don hang
729 uctNhapHang_ChiTiet.uctNh_Ct.HienThiChiTietDonHang(IdNhapHang, nhaCungCapId, trangThaiNhapHang);
730
731 }
732
733 //Click thêm mới bom
734 protected void ThemMoiBom_GoiSanPham(object sender, EventArgs e, int IdBom)
735 {
736 //Form bom
737 ThemTabPages(Views.uctBom_Form.uctBomF, 4, "Thêm mới BOM");
738
739 uctBom_Form.uctBomF.formatUctBomForm_Default();
740
741 }
742
743 //xem chi tiet bom
744 protected void XemChiTiet_Bom_GoiSanPham(object sender, EventArgs e, int IdBom)
745 {
746 //Form bom
747 ThemTabPages(Views.uctBom_ChiTiet.uctBomCt, 4, "Chi tiết gói sản phẩm");
748
749 //hien thi thong tin trong don hang
750 uctBom_ChiTiet.uctBomCt.HienThiChiTietBom(IdBom);
751 }
752
753 //sửa bom
754 protected void SuaBom(object sender, EventArgs e, int IdBom, string _KieuSua_ThemMoi)
755 {
756 this.DongTabHienTai();
757
758 //Form bom
759 ThemTabPages(Views.uctBom_Form.uctBomF, 4, "Thay đổi gói sản phẩm");
760
761 //hien thi thong tin trong don hang
762 uctBom_Form.uctBomF.HienThiChiTietBom(IdBom);
763
764
765 }
766
767 private void khachHangToolStripMenuItem_Click(object sender, EventArgs e)
768 {
769 ThemTabPages(Views.uctQuanLyMuaHang.uctQLMh, 4, "Quản lý mua hàng");
770 //ThemTabPages(Views.uctKhachHang_tbl.uctKh_tbl, 11, "Khách hàng");
771 }
772
773 //kho click kiểm tra kho
774 protected void DanhSachKiemKhoClick(object sender, EventArgs e)
775 {
776 ThemTabPages(Views.uctKho_KiemTraKho_List.uctK_ktk_List, 4, "Danh sách kiểm kho");
777 //Form bom
778 //ThemTabPages(Views.uctKho_KiemTraKho_Form.uctK_ktk_Form, 10, "Kiểm tra kho");
779 }
780
781 //gọi kiểm tra kho form
782 protected void FormKiemKhoClick(object sender, EventArgs e)
783 {
784 ThemTabPages(Views.uctKho_KiemTraKho_Form.uctK_ktk_Form, 4, "Kiểm kho");
785 }
786
787 //chi tiet kiem kho
788 protected void KiemKhoChiTiet(object sender, EventArgs e, int idKiemKho)
789 {
790 ThemTabPages(Views.uctKho_KiemTraKho_ChiTiet.uctKtk_Ct, 4, "Chi tiết kiểm kho");
791
792 //hien thi chi tiet kiem kho
793 uctKho_KiemTraKho_ChiTiet.uctKtk_Ct.HienThiDsChiTietKiemKho(idKiemKho);
794 }
795
796 //thay đổi kiểm kho khi xem chi tiêt
797 protected void KiemKhoChiTietThayDoi(object sender, EventArgs e, int idKiemKho)
798 {
799 ThemTabPages(Views.uctKho_KiemTraKho_Form.uctK_ktk_Form, 4, "Thay đổi thông tin kiểm kho");
800
801 //Hien thị thông tin sp kiểm kho edit
802 uctKho_KiemTraKho_Form.uctK_ktk_Form.HienThiDanhSachSpTrongKho(idKiemKho);
803 }
804
805 //ket thuc ngay lam viec
806 protected void BC_KetThucNgayLamViec(object sender, EventArgs e, DateTime ketThucNgayLv)
807 {
808 ThemTabPages(Views.uctBaoCao_KetThucNgayLamViec.uctBc_Ktnlv, 4, "Báo cáo kết thúc ngày làm việc");
809 uctBaoCao_KetThucNgayLamViec.uctBc_Ktnlv.LoadLai_uctBaoCao_KetThucNgayLamViec();
810 }
811
812 //chi tiết sản phẩm click từ kho
813 protected void ChiTietSanPhamClick(object sender, EventArgs e, int idKho)
814 {
815 ThemTabPages(Views.uctKho_ChiTietSanPham.uctKho_CtSp, 4, "Chi tiết sản phẩm");
816
817 uctKho_ChiTietSanPham.uctKho_CtSp.HienThiThongTinSanPham_ChiTiet(idKho);
818 }
819
820 //bat dau ban hang
821 protected void ClickBatDau_BanHang(object sender, EventArgs e)
822 {
823 ThemTabPages(Views.uctBanHang.uctBH, 4, "Bán hàng");
824 }
825
826 //bat dau nhap hang
827 protected void ClickBatDau_NhapHang(object sender, EventArgs e)
828 {
829 ThemTabPages(Views.uctNhapHang.uctNH, 4, "Nhập hàng");
830 }
831
832 protected void BC_KhoaSoNgayHomNay(object sender, EventArgs e, DateTime dayHome)
833 {
834 ThemTabPages(Views.uctBaoCao_KetThucNgayLamViec.uctBc_Ktnlv, 4, "Kết thúc ngày làm việc");
835 uctBaoCao_KetThucNgayLamViec.uctBc_Ktnlv.LoadLai_uctBaoCao_KetThucNgayLamViec();
836 }
837
838 //tong don hang
839 protected void DB_TongDonHang(object sender, EventArgs e, DateTime ngayHnays)
840 {
841 //ThemTabPages(Views.uctKhachHang_tbl.uctKhTbl, 4, "Chi tiết tổng đơn hàng");
842 ThemTabPages(Views.uctKhachHang_tbl.uctKhTbl, 4, "x");
843 //uctKhachHang_tbl.uctKh_tbl.HienThiDanhSachKhachHang(0, "", "", ngayHnay, 0);
844
845 //--https://stackoverflow.com/questions/19961411/adding-usercontrol-to-tabpage
846 //uctKhachHang_tbl.uctKh_tbl.Dock = DockStyle.Fill;
847 //TabPage myTabPage = new TabPage();
848 //myTabPage.Controls.Add(uctKhachHang_tbl.uctKh_tbl);
849 // myTabPage.Text = "Chi tiết tổng đơn hàng";
850 // tabControl_TabHienThi.TabPages.Add(myTabPage);
851 // uctKhachHang_tbl.uctKh_tbl.Focus();
852
853 //uctKhachHang_tbl.uctKh_tbl.HienThiDanhSachKhachHang(0, "", "", ngayHnay);
854
855 }
856
857 private void congNoBaoCaoToolStripMenuItem_Click(object sender, EventArgs e)
858 {
859 //ThemTabPages(Views.uctKhachHang_tbl.uctKhTbl, 4, "x");
860 ThemTabPages(Views.uctCongNo_Ncc_Kh.uctCn_Ncc_Kh, 4, "Quản lý công nợ");
861 uctCongNo_Ncc_Kh.uctCn_Ncc_Kh.HienThiToanBoTrang();
862 }
863
864 protected void DanhSachTonKho(object sender, EventArgs e)
865 {
866 ThemTabPages(Views.uctKho_DsTonKho.uctK_dsTk, 4, "Danh sách tồn kho");
867
868 //uctKho_DsTonKho.uctK_dsTk.HienThiDsTonKho("", "", 0, 0);
869 uctKho_DsTonKho.uctK_dsTk.CallDsTonKho();
870 }
871
872 //thu chi
873 protected void DanhSach_ThuChi(object sender, EventArgs e)
874 {
875 ThemTabPages(Views.uctCongNo.uctCN, 4, "Danh sách thu chi");
876 }
877
878 //quan ly nha cung cap
879 protected void QuanLy_NhaCungCap(object sender, EventArgs e)
880 {
881 ThemTabPages(Views.uctNhaCungCap.uctNCC, 4, "Nhà cung cấp");
882 }
883
884 //them moi don hang
885 protected void ThemMoiDonHang_NhapHang(object sender, EventArgs e)
886 {
887 while (tabControl_TabHienThi.TabPages.Count > 0)
888 {
889 tabControl_TabHienThi.TabPages.Remove(tabControl_TabHienThi.SelectedTab);
890 }
891
892 ThemTabPages(Views.uctNhapHang.uctNH, 4, "Nhập hàng");
893
894 uctNhapHang.uctNH.HienThiDanhSachSanPham_Kho_ByIdNhapHang(0, 0, "Thêm mới đơn hàng");
895 }
896
897
898 //quan ly kho
899 protected void QuanLy_Kho(object sender, EventArgs e)
900 {
901 ThemTabPages(Views.uctKho.uctK, 4, "Quản lý kho");
902 }
903
904 //cau hinh ht
905 protected void CauHinhHt(object sender, EventArgs e)
906 {
907 ThemTabPages(Views.uctCauHinhHeThong.uctCHHT, 4, "Cấu hình hệ thống");
908 }
909
910 //ds san pham da ba
911 protected void DsSanPhamDaBan(object sender , EventArgs e)
912 {
913 ThemTabPages(Views.uctQuanLyMuaHang.uctQLMh, 4, "Danh sách bán hàng");
914 uctQuanLyMuaHang.uctQLMh.HienThiDsSpDaBan();
915 }
916
917 //bom va goi san pham
918 protected void BomVaGoiSanPham(object sender, EventArgs e)
919 {
920 ThemTabPages(Views.uctBom_GoiSanPham.uctBomGsp, 4, "BOM & Gói sản phẩm");
921 }
922
923 //uctbom form quay lai
924 protected void BomQuayLai(object sender, EventArgs e)
925 {
926 DongTabHienTai();
927
928 ThemTabPages(Views.uctBom_GoiSanPham.uctBomGsp, 4, "BOM & Gói sản phẩm");
929 }
930
931 //chi tiet bom quay lay
932 protected void BomChiTietQuayLai(object sender, EventArgs e)
933 {
934 DongTabHienTai();
935 ThemTabPages(Views.uctBom_GoiSanPham.uctBomGsp, 4, "BOM & Gói sản phẩm");
936 }
937 //hien thi danh sach nha cc
938 protected void HienThiDsNcc(object sender, EventArgs e, int idNcc)
939 {
940 ThemTabPages(Views.uctQuanLyHoaDon.uctQLHD, 4, "Danh sách đơn hàng");
941
942 uctQuanLyHoaDon.uctQLHD.HienThiTheoNCC(idNcc);
943 }
944
945 //dong nhap hang chi tiet chuyen sang danh sach nhap hang
946 protected void DongNhapHangChiTiet(object sender, EventArgs e)
947 {
948 DongTabHienTai();
949
950 ThemTabPages(Views.uctQuanLyHoaDon.uctQLHD, 4, "Danh sách nhập hàng");
951
952 uctQuanLyHoaDon.uctQLHD.HienThiDsNhapH();
953 }
954
955
956 //chi phi
957 protected void BC_ThemGet_Uct_BaoCao_HienTHi(object sender, EventArgs e)
958 {
959 ThemTabPages(Views.uctBaoCao_HienThi.uctBC_Ht, 4, "Báo cáo Thu Chi");
960 //1 la chi phi
961 uctBaoCao_HienThi.uctBC_Ht.HienThiUct_Bc_Ht(1);
962 }
963
964 //bao cao hang ton kho
965 protected void BC_HangTonKho(object sender, EventArgs e)
966 {
967 //ThemTabPages(Views.uctBaoCao_HienThi.uctBC_Ht, 4, "Báo cáo tồn kho");
968
969 //uctBaoCao_HienThi.uctBC_Ht.HienThiUct_Bc_Ht(2);
970
971 ThemTabPages(Views.uctKho_DsTonKho.uctK_dsTk, 4, "Báo cáo tồn kho");
972
973
974 //uctKho_DsTonKho.uctK_dsTk.HienThiDsTonKho("", "", 0, 0);
975 uctKho_DsTonKho.uctK_dsTk.CallDsTonKho();
976
977 }
978
979
980 //bom va goi sp
981 protected void BC_BomVaGoiSp(object sender, EventArgs e)
982 {
983
984 }
985
986 //san pham
987 protected void BC_DsSanPham(object sender, EventArgs e)
988 {
989
990 }
991
992 //nhap hang
993 protected void BC_DsNhapHang(object sender, EventArgs e)
994 {
995
996 }
997
998 //cong no ncc
999 protected void BC_CongNoNcc(object sender, EventArgs e)
1000 {
1001
1002 }
1003
1004 //nha cc
1005 protected void BC_DsNhaCc(object sender, EventArgs e)
1006 {
1007
1008 }
1009
1010 //tam dung dh
1011 protected void BC_DsTamDungDonNhangNhapHang(object sender, EventArgs e)
1012 {
1013
1014 }
1015
1016 private void scannerToolStripMenuItem_Click(object sender, EventArgs e)
1017 {
1018 ThemTabPages(Views.uctScanner.uctSc, 4, "Scanner");
1019 }
1020
1021 //update spkho
1022 protected void HienThiThongTinSpKhoKhiUpdate(object sender, EventArgs e)
1023 {
1024 uctKho.uctK.HienThiLaiDsKho();
1025 }
1026
1027 //--https://stackoverflow.com/questions/15680323/change-background-color-of-menustrip
1028 private void ctxtmenuTabBan_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
1029 {
1030 if (e.ClickedItem.BackColor != Color.LightGray)
1031 {
1032 //e.ClickedItem.BackColor = Color.White;
1033
1034
1035 }
1036
1037 }
1038 //
1039 }
1040 }